<?php 
 require_once('nav.php');
connect();
$search=$_POST['search'];

$sql="select * from users where uname like '%{$search}%' ";
$result=fetch_array($sql) or die('查询失败！'.mysql_error());
 ?>
   <div class="col-sm-9 col-md-10">
   <center><h3>用户列表</h3></center>
   <table class="table table-hover">
   	<tr>
     <th>用户编号</th>
     <th>用户名</th>   
     <th>性别</th>
     <th>生日</th>
     <th>爱好</th>
     <th>学历</th>
     <th>自我介绍</th> 
     <th width='80'>头像</th>
     <th>操作</th>
   </tr>

   <?php
    foreach ($result as $row) {
     echo '<tr>';
     echo '<td>'.$row['uid'].'</td>';
     echo '<td>'.$row['uname'].'</td>';  
     echo '<td>'.($row['gender']==0?'男':'女').'</td>';
     echo '<td>'.$row['birthdate'].'</td>';
     echo '<td>'.$row['hobby'].'</td>';
     switch($row['degree']){
       case '1':$dg = "高中";break;
       case '2':$dg = "大学";break;
       case '3':$dg = "研究生";break;
       case '4':$dg = "博士生";break;
       default: $dg="不知道";
       }
     echo '<td>'.$dg.'</td>';
     echo '<td>'.$row['intro'].'</td>';    
    echo '<td align="center"><img src="../images/'.$row['pic'].'" width=75 height=90 alt="无图片"></td>'; 
     echo '<td><a href="userEdit-Form.php?id='.$row['uid'].' ">修改</a> | 
     <a href="userDelete.php?id='.$row['uid'].'" onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';
     echo '</tr>';  
    }
    echo '</table>';  
    $totalrows = count($result);
    echo "<table align='center'><tr><td>共有{$totalrows}名用户</td></tr></table>"   
   ?>
</div>